2015-06-12 - 19912 - Spec - Drop Ship Order Logic Change #SalesDistribution

SPECIFICATIONS

19912 - Drop Ship Order Logic Change

Purpose

---

Need to change logic for Drop Ship Orders in Open Order Cube.

Admin Info

---

Purpose	Need to change logic for Drop Ship Orders in Open Order Cube.
Requested By	Mark Harris
Spec Created By	Naveen G
Spec Created Date	06/12/2015
Spec QA by	Uday Kumar P
Objects	2LIS_11_VASTI, ZSD_O04
Document Status	Complete

Estimates

---

SNo	Activity	Estimation in Hours
1	Research	04
2	Documentation	04
3	Development/ Config	24
4	Unit test in DEV	08
5	Unit test in QUA	04
6	Other activity	24
	TOTAL	58

References

---

Prior Tickets

None

Documents

None

Spec Changes

---

SNo	Change Details	Requested By	Requested On	Notes if any

Functional Requirement

---

Purpose/WHY:

Email From Mark H on 06/10/2015:
What I need you to work on is an issue with drop ship orders in the open order cube Right now we have logic that if the billing status at the header is "fully invoiced" I think "C" then we exclude it from the cube.
I need you to change that to use the same logic at the line level not the header Take a look and we will talk about it

In Scope:

Open Order Infocube.

Out of Scope:

None

Solution Summary

---

1. Need to activate 2LIS_11_VASTI datasource & add item category field to the extractor.
2. Need to write necessary logic in the CMOD, to fetch data for item category.
3. Need to create a new Order items status DSO & map it with the extractor.
4. Need to change the lookup logic for Global & regional open order cubes.
5. Need to make necessary changes to order header process chain.
5. Need to validate the data in BPD & BPQ
5. Need to collect all the changes in the transport requests.

Test Plan

SNo	Test Scenario	Expected Results
1	Check if the enhancement logic is fetching data as per the requirement.	Enhancement Logic should populate data as per the requirement.
2	Check if the logic in the open order cube is working correctly.	Logic to lookup Order item status should work correctly.
3	Check if data is validated successfully in BPD & BPQ.	Data should be validated successfully.
4	Check if all the objetcs are collected into the transport request.	All the objects should be collected into the transport request.

Solution Details

---

1. Need to activate 2LIS_11_VASTI datasource & add item category field PSTYV to the extractor.
2. Need to write necessary logic in the CMOD, to fetch data for item category PSTYV.
3. Need to create a new Order items status DSO ZSD_O04 & map it with the extractor 2LIS_11_VASTI.
4. Need to change the lookup logic for Global & regional open order cubes.
5. Need to make necessary changes to order header process chain ZPC_ORDER_STATUS.
5. Need to validate the data in BPD & BPQ
5. Need to collect all the changes in the transport requests.

Issues

---

None